using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

/// <summary>
/// Summary description for objNTV_kinh_nghiem
/// </summary>
public class objNTV_kinh_nghiem
{
    Common comm = new Common();

    private string _ma_kinh_nghiem;
    private  string _ma_chuc_danh, _chuc_danh, _ten_cong_ty, _dia_chi_cong_ty, _ma_dia_chi;
    private  DateTime _ngay_bat_dau, _ngay_ket_thuc;
    private decimal _muc_luong;
    private string _ly_do_nghi, _mo_ta;

    public objNTV_kinh_nghiem()
    {
    }
    public objNTV_kinh_nghiem(string ma_kn)
    {   
        string sqlComm = "Select * from NguoiTimViec_kinh_nghiem_lam_viec where ma_kinh_nghiem='" + ma_kn + "'";
        DataTable dtt = comm.getDataTable(sqlComm);
        if (dtt.Rows.Count > 0)
        {
            _ma_kinh_nghiem = ma_kn;
            _chuc_danh = dtt.Rows[0]["chuc_danh"].ToString();
            _dia_chi_cong_ty = dtt.Rows[0]["dia_chi_cong_ty"].ToString();
            _ly_do_nghi = dtt.Rows[0]["ly_do_nghi"].ToString();
            _ma_chuc_danh = dtt.Rows[0]["ma_chuc_danh"].ToString();
            _ma_dia_chi = dtt.Rows[0]["ma_dia_chi"].ToString();
            _mo_ta = dtt.Rows[0]["mo_ta"].ToString();
            _muc_luong =Decimal.Parse(dtt.Rows[0]["muc_luong"].ToString());
            _ngay_bat_dau =DateTime.Parse(dtt.Rows[0]["ngay_bat_dau"].ToString());
            _ngay_ket_thuc =DateTime.Parse( dtt.Rows[0]["ngay_ket_thuc"].ToString());
            _ten_cong_ty = dtt.Rows[0]["ten_cong_ty"].ToString();
        }
    }

    public string ma_kinh_nghiem
    {
        get
        {
            return _ma_kinh_nghiem;
        }
        set
        {
            this._ma_kinh_nghiem = value;

        }
    }
    public string ma_chuc_danh
    {
        get
        {
            return _ma_chuc_danh;
        }
        set
        {
            this._ma_chuc_danh = value;

        }
    }
    public string chuc_danh
    {
        get
        {
            return _chuc_danh;
        }
        set
        {
            this._chuc_danh = value;

        }
    }
    public string ten_cong_ty
    {
        get
        {
            return _ten_cong_ty;
        }
        set
        {
            this._ten_cong_ty = value;

        }
    }
    public string dia_chi_cong_ty
    {
        get
        {
            return _dia_chi_cong_ty;
        }
        set
        {
            this._dia_chi_cong_ty = value;

        }
    }
    public string ma_dia_chi
    {
        get
        {
            return _ma_dia_chi;
        }
        set
        {
            this._ma_dia_chi = value;

        }
    }
    public string ly_do_nghi
    {
        get
        {
            return _ly_do_nghi;
        }
        set
        {
            this._ly_do_nghi = value;

        }
    }
    public string mo_ta
    {
        get
        {
            return _mo_ta;
        }
        set
        {
            this._mo_ta = value;

        }
    }
    public DateTime ngay_bat_dau
    {
        get
        {
            return _ngay_bat_dau;
        }
        set
        {
            this._ngay_bat_dau = value;
           
        }
    }
    public DateTime ngay_ket_thuc
    {
        get
        {
            return _ngay_ket_thuc;
        }
        set
        {
            this._ngay_ket_thuc = value;

        }
    }
    public System.Nullable<Decimal> muc_luong
    {
        get
        {
            return _muc_luong;
        }
        set
        {
            this._muc_luong = value.Value;

        }
    }
}
